<?xml version="1.0" encoding="UTF-8"?>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.1" Build="10.50.1746.0">
   <BatchSequence>
      <Batch>
         <Statements>
            <StmtSimple StatementText="with fights as (&#xA;  select myAnswer.ParentId as Question,&#xA;   myAnswer.Score as MyScore,&#xA;   jonsAnswer.Score as JonsScore&#xA;  from Posts as myAnswer&#xA;  inner join Posts as jonsAnswer&#xA;   on jonsAnswer.OwnerUserId = 22656 and myAnswer.ParentId = jonsAnswer.ParentId&#xA;  where myAnswer.ownerUserId = @UserId and myAnswer.postTypeId = 2&#xA;)&#xA;&#xA;select&#xA;  case&#xA;   when myScore &gt; JonsScore then 'You win'&#xA;   when myScore &lt; JonsScore then 'Jon wins'&#xA;   else 'Tie'&#xA;  end as 'Winner',&#xA;  Question as [Post Link],&#xA;  myScore as 'My score',&#xA;  jonsScore as &quot;Jon's score&quot;&#xA;from fights;" StatementId="1" StatementCompId="2" StatementType="SELECT" StatementSubTreeCost="0.101798" StatementEstRows="4.53196" StatementOptmLevel="FULL" QueryHash="0xACC1BD742B46BB99" QueryPlanHash="0x8A993A827E088406" StatementOptmEarlyAbortReason="GoodEnoughPlanFound">
               <StatementSetOptions QUOTED_IDENTIFIER="true" ARITHABORT="false" CONCAT_NULL_YIELDS_NULL="true" ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" NUMERIC_ROUNDABORT="false" />
               <QueryPlan DegreeOfParallelism="1" MemoryGrant="1632" CachedPlanSize="40" CompileTime="6" CompileCPU="6" CompileMemory="464">
                  <RelOp NodeId="0" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="4.53196" EstimateIO="0" EstimateCPU="4.53196e-007" AvgRowSize="27" EstimatedTotalSubtreeCost="0.101798" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                     <OutputList>
                        <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="ParentId" />
                        <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Score" />
                        <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Score" />
                        <ColumnReference Column="Expr1004" />
                     </OutputList>
                     <ComputeScalar>
                        <DefinedValues>
                           <DefinedValue>
                              <ColumnReference Column="Expr1004" />
                              <ScalarOperator ScalarString="CASE WHEN [StackOverflow.Exported].[dbo].[Posts].[Score] as [myAnswer].[Score]&gt;[StackOverflow.Exported].[dbo].[Posts].[Score] as [jonsAnswer].[Score] THEN 'You win' ELSE CASE WHEN [StackOverflow.Exported].[dbo].[Posts].[Score] as [myAnswer].[Score]&lt;[StackOverflow.Exported].[dbo].[Posts].[Score] as [jonsAnswer].[Score] THEN 'Jon wins' ELSE 'Tie' END END">
                                 <IF>
                                    <Condition>
                                       <ScalarOperator>
                                          <Compare CompareOp="GT">
                                             <ScalarOperator>
                                                <Identifier>
                                                   <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Score" />
                                                </Identifier>
                                             </ScalarOperator>
                                             <ScalarOperator>
                                                <Identifier>
                                                   <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Score" />
                                                </Identifier>
                                             </ScalarOperator>
                                          </Compare>
                                       </ScalarOperator>
                                    </Condition>
                                    <Then>
                                       <ScalarOperator>
                                          <Const ConstValue="'You win'" />
                                       </ScalarOperator>
                                    </Then>
                                    <Else>
                                       <ScalarOperator>
                                          <IF>
                                             <Condition>
                                                <ScalarOperator>
                                                   <Compare CompareOp="LT">
                                                      <ScalarOperator>
                                                         <Identifier>
                                                            <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Score" />
                                                         </Identifier>
                                                      </ScalarOperator>
                                                      <ScalarOperator>
                                                         <Identifier>
                                                            <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Score" />
                                                         </Identifier>
                                                      </ScalarOperator>
                                                   </Compare>
                                                </ScalarOperator>
                                             </Condition>
                                             <Then>
                                                <ScalarOperator>
                                                   <Const ConstValue="'Jon wins'" />
                                                </ScalarOperator>
                                             </Then>
                                             <Else>
                                                <ScalarOperator>
                                                   <Const ConstValue="'Tie'" />
                                                </ScalarOperator>
                                             </Else>
                                          </IF>
                                       </ScalarOperator>
                                    </Else>
                                 </IF>
                              </ScalarOperator>
                           </DefinedValue>
                        </DefinedValues>
                        <RelOp NodeId="1" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="17.0221" EstimateIO="0" EstimateCPU="7.11525e-005" AvgRowSize="23" EstimatedTotalSubtreeCost="0.101789" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                           <OutputList>
                              <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="ParentId" />
                              <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Score" />
                              <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Score" />
                           </OutputList>
                           <RunTimeInformation>
                              <RunTimeCountersPerThread Thread="0" ActualRows="4" ActualEndOfScans="1" ActualExecutions="1" />
                           </RunTimeInformation>
                           <NestedLoops Optimized="1">
                              <OuterReferences>
                                 <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Id" />
                              </OuterReferences>
                              <RelOp NodeId="3" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="17.0221" EstimateIO="0" EstimateCPU="7.11525e-005" AvgRowSize="19" EstimatedTotalSubtreeCost="0.0677772" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                 <OutputList>
                                    <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="ParentId" />
                                    <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Score" />
                                    <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Id" />
                                 </OutputList>
                                 <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="2063" ActualEndOfScans="1" ActualExecutions="1" />
                                 </RunTimeInformation>
                                 <NestedLoops Optimized="1">
                                    <OuterReferences>
                                       <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="ParentId" />
                                    </OuterReferences>
                                    <RelOp NodeId="5" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="12.5504" EstimateIO="0" EstimateCPU="5.24608e-005" AvgRowSize="16" EstimatedTotalSubtreeCost="0.0414273" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                       <OutputList>
                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="ParentId" />
                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Score" />
                                       </OutputList>
                                       <RunTimeInformation>
                                          <RunTimeCountersPerThread Thread="0" ActualRows="166" ActualEndOfScans="1" ActualExecutions="1" />
                                       </RunTimeInformation>
                                       <NestedLoops Optimized="1">
                                          <OuterReferences>
                                             <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Id" />
                                          </OuterReferences>
                                          <RelOp NodeId="7" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="12.5504" EstimateIO="0.003125" EstimateCPU="0.000170805" AvgRowSize="15" EstimatedTotalSubtreeCost="0.00329581" TableCardinality="4.18708e+006" Parallel="0" EstimateRebinds="0" EstimateRewinds="0">
                                             <OutputList>
                                                <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Id" />
                                                <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="ParentId" />
                                             </OutputList>
                                             <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="0" ActualRows="181" ActualEndOfScans="1" ActualExecutions="1" />
                                             </RunTimeInformation>
                                             <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                                <DefinedValues>
                                                   <DefinedValue>
                                                      <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Id" />
                                                   </DefinedValue>
                                                   <DefinedValue>
                                                      <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="ParentId" />
                                                   </DefinedValue>
                                                </DefinedValues>
                                                <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[idxPostOwner]" Alias="[myAnswer]" IndexKind="NonClustered" />
                                                <SeekPredicates>
                                                   <SeekPredicateNew>
                                                      <SeekKeys>
                                                         <Prefix ScanType="EQ">
                                                            <RangeColumns>
                                                               <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="OwnerUserId" />
                                                            </RangeColumns>
                                                            <RangeExpressions>
                                                               <ScalarOperator ScalarString="[@UserId]">
                                                                  <Identifier>
                                                                     <ColumnReference Column="@UserId" />
                                                                  </Identifier>
                                                               </ScalarOperator>
                                                            </RangeExpressions>
                                                         </Prefix>
                                                      </SeekKeys>
                                                   </SeekPredicateNew>
                                                </SeekPredicates>
                                             </IndexScan>
                                          </RelOp>
                                          <RelOp NodeId="9" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="8.95665" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="12" EstimatedTotalSubtreeCost="0.0380791" TableCardinality="4.18708e+006" Parallel="0" EstimateRebinds="11.5504" EstimateRewinds="0">
                                             <OutputList>
                                                <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Score" />
                                             </OutputList>
                                             <RunTimeInformation>
                                                <RunTimeCountersPerThread Thread="0" ActualRows="166" ActualEndOfScans="15" ActualExecutions="181" />
                                             </RunTimeInformation>
                                             <IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                                <DefinedValues>
                                                   <DefinedValue>
                                                      <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Score" />
                                                   </DefinedValue>
                                                </DefinedValues>
                                                <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[idxId]" Alias="[myAnswer]" TableReferenceId="-1" IndexKind="Clustered" />
                                                <SeekPredicates>
                                                   <SeekPredicateNew>
                                                      <SeekKeys>
                                                         <Prefix ScanType="EQ">
                                                            <RangeColumns>
                                                               <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Id" />
                                                            </RangeColumns>
                                                            <RangeExpressions>
                                                               <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[Id] as [myAnswer].[Id]">
                                                                  <Identifier>
                                                                     <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="Id" />
                                                                  </Identifier>
                                                               </ScalarOperator>
                                                            </RangeExpressions>
                                                         </Prefix>
                                                      </SeekKeys>
                                                   </SeekPredicateNew>
                                                </SeekPredicates>
                                                <Predicate>
                                                   <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[PostTypeId] as [myAnswer].[PostTypeId]=(2)">
                                                      <Compare CompareOp="EQ">
                                                         <ScalarOperator>
                                                            <Identifier>
                                                               <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="PostTypeId" />
                                                            </Identifier>
                                                         </ScalarOperator>
                                                         <ScalarOperator>
                                                            <Const ConstValue="(2)" />
                                                         </ScalarOperator>
                                                      </Compare>
                                                   </ScalarOperator>
                                                </Predicate>
                                             </IndexScan>
                                          </RelOp>
                                       </NestedLoops>
                                    </RelOp>
                                    <RelOp NodeId="13" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1.9005" EstimateIO="0.003125" EstimateCPU="0.000159091" AvgRowSize="11" EstimatedTotalSubtreeCost="0.0262727" TableCardinality="4.18708e+006" Parallel="0" EstimateRebinds="7.95665" EstimateRewinds="0">
                                       <OutputList>
                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Id" />
                                       </OutputList>
                                       <RunTimeInformation>
                                          <RunTimeCountersPerThread Thread="0" ActualRows="2063" ActualEndOfScans="166" ActualExecutions="166" />
                                       </RunTimeInformation>
                                       <IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                          <DefinedValues>
                                             <DefinedValue>
                                                <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Id" />
                                             </DefinedValue>
                                          </DefinedValues>
                                          <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[ParentIdIdx]" Alias="[jonsAnswer]" IndexKind="NonClustered" />
                                          <SeekPredicates>
                                             <SeekPredicateNew>
                                                <SeekKeys>
                                                   <Prefix ScanType="EQ">
                                                      <RangeColumns>
                                                         <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="ParentId" />
                                                      </RangeColumns>
                                                      <RangeExpressions>
                                                         <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[ParentId] as [myAnswer].[ParentId]">
                                                            <Identifier>
                                                               <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[myAnswer]" Column="ParentId" />
                                                            </Identifier>
                                                         </ScalarOperator>
                                                      </RangeExpressions>
                                                   </Prefix>
                                                </SeekKeys>
                                             </SeekPredicateNew>
                                          </SeekPredicates>
                                       </IndexScan>
                                    </RelOp>
                                 </NestedLoops>
                              </RelOp>
                              <RelOp NodeId="15" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="4.53196" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="15" EstimatedTotalSubtreeCost="0.033941" TableCardinality="4.18708e+006" Parallel="0" EstimateRebinds="15.3199" EstimateRewinds="0.702213">
                                 <OutputList>
                                    <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Score" />
                                 </OutputList>
                                 <RunTimeInformation>
                                    <RunTimeCountersPerThread Thread="0" ActualRows="4" ActualEndOfScans="2059" ActualExecutions="2063" />
                                 </RunTimeInformation>
                                 <IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" NoExpandHint="0">
                                    <DefinedValues>
                                       <DefinedValue>
                                          <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Score" />
                                       </DefinedValue>
                                    </DefinedValues>
                                    <Object Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Index="[idxId]" Alias="[jonsAnswer]" TableReferenceId="-1" IndexKind="Clustered" />
                                    <SeekPredicates>
                                       <SeekPredicateNew>
                                          <SeekKeys>
                                             <Prefix ScanType="EQ">
                                                <RangeColumns>
                                                   <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Id" />
                                                </RangeColumns>
                                                <RangeExpressions>
                                                   <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[Id] as [jonsAnswer].[Id]">
                                                      <Identifier>
                                                         <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="Id" />
                                                      </Identifier>
                                                   </ScalarOperator>
                                                </RangeExpressions>
                                             </Prefix>
                                          </SeekKeys>
                                       </SeekPredicateNew>
                                    </SeekPredicates>
                                    <Predicate>
                                       <ScalarOperator ScalarString="[StackOverflow.Exported].[dbo].[Posts].[OwnerUserId] as [jonsAnswer].[OwnerUserId]=(22656)">
                                          <Compare CompareOp="EQ">
                                             <ScalarOperator>
                                                <Identifier>
                                                   <ColumnReference Database="[StackOverflow.Exported]" Schema="[dbo]" Table="[Posts]" Alias="[jonsAnswer]" Column="OwnerUserId" />
                                                </Identifier>
                                             </ScalarOperator>
                                             <ScalarOperator>
                                                <Const ConstValue="(22656)" />
                                             </ScalarOperator>
                                          </Compare>
                                       </ScalarOperator>
                                    </Predicate>
                                 </IndexScan>
                              </RelOp>
                           </NestedLoops>
                        </RelOp>
                     </ComputeScalar>
                  </RelOp>
                  <ParameterList>
                     <ColumnReference Column="@UserId" ParameterRuntimeValue="(1)" />
                  </ParameterList>
               </QueryPlan>
            </StmtSimple>
         </Statements>
      </Batch>
   </BatchSequence>
</ShowPlanXML>